﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.Text;
using System.Threading.Tasks;

namespace Model
{

    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("BatchOderInfo", "BatchOderInfo", new string[] { "GOODSID" })]
    [KnownType(typeof(BatchOrderInfo))]
    public class BatchOrderInfo : MB.Orm.Common.BaseModel
    {
        private int _GOODSID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GOODSID", System.Data.DbType.Int32)]
        public int GOODSID
        {
            get { return _GOODSID; }
            set { _GOODSID = value; }
        }
        private int _BATCHNUMBER;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCHNUMBER", System.Data.DbType.Int32)]
        public int BATCHNUMBER
        {
            get { return _BATCHNUMBER; }
            set { _BATCHNUMBER = value; }
        }
        private decimal _QTY;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("QTY", System.Data.DbType.Decimal)]
        public decimal QTY
        {
            get { return _QTY; }
            set { _QTY = value; }
        }
        private string _GOODSCODE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GOODSCODE", System.Data.DbType.String)]
        public string GOODSCODE
        {
            get { return _GOODSCODE; }
            set { _GOODSCODE = value; }
        }
        private string _GOODSNAME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GOODSNAME", System.Data.DbType.String)]
        public string GOODSNAME
        {
            get { return _GOODSNAME; }
            set { _GOODSNAME = value; }
        }
        private decimal _DQTY;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DQTY", System.Data.DbType.Decimal)]
        public decimal DQTY
        {
            get { return _DQTY; }
            set { _DQTY = value; }
        }

        private string _DGOODSCODE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DGOODSCODE", System.Data.DbType.String)]
        public string DGOODSCODE
        {
            get { return _DGOODSCODE; }
            set { _DGOODSCODE = value; }
        }

        private string _DGOODSNAME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DGOODSNAME", System.Data.DbType.String)]
        public string DGOODSNAME
        {
            get { return _DGOODSNAME; }
            set { _DGOODSNAME = value; }
        }
        private string _DGOODSSPCE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DGOODSSPCE", System.Data.DbType.String)]
        public string DGOODSSPCE
        {
            get { return _DGOODSSPCE; }
            set { _DGOODSSPCE = value; }
        }

        private string _DUNITNAME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DUNITNAME", System.Data.DbType.String)]
        public string DUNITNAME
        {
            get { return _DUNITNAME; }
            set { _DUNITNAME = value; }
        }
        private string _LOOKUP;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("LOOKUP", System.Data.DbType.String)]
        public string LOOKUP
        {
            get { return _LOOKUP; }
            set { _LOOKUP = value; }
        }
        private string _GOODSSPEC;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GOODSSPEC", System.Data.DbType.String)]
        public string GOODSSPEC
        {
            get { return _GOODSSPEC; }
            set { _GOODSSPEC = value; }
        }
        private string _RATIONDATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("RATIONDATE", System.Data.DbType.String)]
        public string RATIONDATE
        {
            get { return _RATIONDATE; }
            set { _RATIONDATE = value; }
        }
        private int _BATCH_1;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_1", System.Data.DbType.Int32)]
        public int BATCH_1
        {
            get { return _BATCH_1; }
            set { _BATCH_1 = value; }
        }
        private int _BATCH_2;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_2", System.Data.DbType.Int32)]
        public int BATCH_2
        {
            get { return _BATCH_2; }
            set { _BATCH_2 = value; }
        }
        private int _BATCH_3;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_3", System.Data.DbType.Int32)]
        public int BATCH_3
        {
            get { return _BATCH_3; }
            set { _BATCH_3 = value; }
        }
        private int _BATCH_4;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_4", System.Data.DbType.Int32)]
        public int BATCH_4
        {
            get { return _BATCH_4; }
            set { _BATCH_4 = value; }
        }
        private int _BATCH_5;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_5", System.Data.DbType.Int32)]
        public int BATCH_5
        {
            get { return _BATCH_5; }
            set { _BATCH_5 = value; }
        }
        private int _BATCH_6;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_6", System.Data.DbType.Int32)]
        public int BATCH_6
        {
            get { return _BATCH_6; }
            set { _BATCH_6 = value; }
        }
        private int _BATCH_7;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_7", System.Data.DbType.Int32)]
        public int BATCH_7
        {
            get { return _BATCH_7; }
            set { _BATCH_7 = value; }
        }
        private int _BATCH_8;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_8", System.Data.DbType.Int32)]
        public int BATCH_8
        {
            get { return _BATCH_8; }
            set { _BATCH_8 = value; }
        }
        private int _BATCH_9;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_9", System.Data.DbType.Int32)]
        public int BATCH_9
        {
            get { return _BATCH_9; }
            set { _BATCH_9 = value; }
        }
        private int _BATCH_10;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_10", System.Data.DbType.Int32)]
        public int BATCH_10
        {
            get { return _BATCH_10; }
            set { _BATCH_10 = value; }
        }
        private int _BATCH_11;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_11", System.Data.DbType.Int32)]
        public int BATCH_11
        {
            get { return _BATCH_11; }
            set { _BATCH_11 = value; }
        }
        private int _BATCH_12;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_12", System.Data.DbType.Int32)]
        public int BATCH_12
        {
            get { return _BATCH_12; }
            set { _BATCH_12 = value; }
        }
        private int _BATCH_13;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_13", System.Data.DbType.Int32)]
        public int BATCH_13
        {
            get { return _BATCH_13; }
            set { _BATCH_13 = value; }
        }
        private int _BATCH_14;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_14", System.Data.DbType.Int32)]
        public int BATCH_14
        {
            get { return _BATCH_14; }
            set { _BATCH_14 = value; }
        }
        private int _BATCH_15;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_15", System.Data.DbType.Int32)]
        public int BATCH_15
        {
            get { return _BATCH_15; }
            set { _BATCH_15 = value; }
        }
        private int _BATCH_16;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_16", System.Data.DbType.Int32)]
        public int BATCH_16
        {
            get { return _BATCH_16; }
            set { _BATCH_16 = value; }
        }
        private int _BATCH_17;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_17", System.Data.DbType.Int32)]
        public int BATCH_17
        {
            get { return _BATCH_17; }
            set { _BATCH_17 = value; }
        }
        private int _BATCH_18;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_18", System.Data.DbType.Int32)]
        public int BATCH_18
        {
            get { return _BATCH_18; }
            set { _BATCH_18 = value; }
        }
        private int _BATCH_19;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_19", System.Data.DbType.Int32)]
        public int BATCH_19
        {
            get { return _BATCH_19; }
            set { _BATCH_19 = value; }
        }
        private int _BATCH_20;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_20", System.Data.DbType.Int32)]
        public int BATCH_20
        {
            get { return _BATCH_20; }
            set { _BATCH_20 = value; }
        }
        private int _BATCH_21;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_21", System.Data.DbType.Int32)]
        public int BATCH_21
        {
            get { return _BATCH_21; }
            set { _BATCH_21 = value; }
        }
        private int _BATCH_22;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_22", System.Data.DbType.Int32)]
        public int BATCH_22
        {
            get { return _BATCH_22; }
            set { _BATCH_22 = value; }
        }
        private int _BATCH_23;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_23", System.Data.DbType.Int32)]
        public int BATCH_23
        {
            get { return _BATCH_23; }
            set { _BATCH_23 = value; }
        }
        private int _BATCH_24;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_24", System.Data.DbType.Int32)]
        public int BATCH_24
        {
            get { return _BATCH_24; }
            set { _BATCH_24 = value; }
        }
        private int _BATCH_25;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_25", System.Data.DbType.Int32)]
        public int BATCH_25
        {
            get { return _BATCH_25; }
            set { _BATCH_25 = value; }
        }
        private int _BATCH_26;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_26", System.Data.DbType.Int32)]
        public int BATCH_26
        {
            get { return _BATCH_26; }
            set { _BATCH_26 = value; }
        }
        private int _BATCH_27;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_27", System.Data.DbType.Int32)]
        public int BATCH_27
        {
            get { return _BATCH_27; }
            set { _BATCH_27 = value; }
        }
        private int _BATCH_28;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_28", System.Data.DbType.Int32)]
        public int BATCH_28
        {
            get { return _BATCH_28; }
            set { _BATCH_28 = value; }
        }
        private int _TOTAL;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTAL ", System.Data.DbType.Int32)]
        public int TOTAL
        {
            get { return _TOTAL; }
            set { _TOTAL = value; }
        }
    }

    public class OrderBatchGroupBy
    {
        public int BATCHNO { get; set; }
        public string RATIONDATE { get; set; }
    }

}
